Release 10.1A: OpenEdge Data Management:
Database Administration

PROUTIL SETBLOBTOSSLIMIT qualifier

Set the toss limit for the specified BLOB.

Syntax

proutil db-name -C setblobtosslimit blob-id toss-limit

Parameters

db-name

Specifies the database where you are setting the toss limit.

blob-id

Specifies the BLOB object for which you are setting the toss limit.

toss-limit

Specifies the new toss limit.

Notes

For a Type II area, SETBLOBTOSSLIMIT sets the BLOB toss limit for the specified BLOB. For a Type I area, SETBLOBTOSSLIMIT issues a warning that all tables and BLOBs in an area must have the same toss limit, and prompts you to confirm setting the toss limit for all tables and BLOBs in the area containing the specified BLOB.
The toss limit value must be greater than 0 and less than the block size minus 128 bytes.
For databases with a 1K block size, the default toss limit is 150. For all other database block sizes, the default toss limit is 300.
The database must be offline when setting toss limits.
For more information on setting toss limits, see the "Database fragmentation" section.